import ctypes
import openpyxl
from prettytable import PrettyTable
from tools_pmc import (fill_blue, fill_yellow,
                       today_str1, yesterday_str2, yesterday_str1, str1, str2,
                       alignment_center, alignment_left, alignment_right,
                       vlookup, vlookup_two, find_max_length, chengtao_sn,
                       lj_wlxxb, lj_tyl,
                       )

hwnd = ctypes.windll.kernel32.GetConsoleWindow()
ctypes.windll.user32.SetWindowPos(hwnd, 300, 300, 1000, 600, 0)

wb_tyl = openpyxl.load_workbook(lj_tyl)
ws_tyl = wb_tyl.worksheets[0]

x = 1
while x != 0:
    print("请输入需要查询的品号：")
    x = int(input())
    print(chengtao_sn(x, ws_tyl))
